package com.jic.data.service.impl;

import com.alibaba.druid.util.StringUtils;
import com.alibaba.fastjson.JSONArray;
import com.alibaba.fastjson.JSONObject;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.jic.data.constant.consist.ResponseCode;
import com.jic.data.exception.AppRuntimeException;
import com.jic.data.mapper.MemberConsumeAmountStsMapper;
import com.jic.data.model.entity.MemberConsumeAmountIntervalSts;
import com.jic.data.model.entity.MemberConsumeAmountSts;
import com.jic.data.service.MemberConsumeAmountStsService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.stereotype.Service;

import javax.annotation.Resource;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 接口实现类
 *
 * @author : 建投数据科技(山东)有限公司
 * @version : v1.0.0
 * @email :
 * @since : 2020-03-09 10:12:20
 */
@Service
@Slf4j
public class MemberConsumeAmountStsServiceImpl implements MemberConsumeAmountStsService {

    @Resource
    private MemberConsumeAmountStsMapper mapper;


    /**
     * 新增记录
     *
     * @param request 需要保存的入参实体类
     * @return int 是否保存成功
     */
    @Override
    public int save(MemberConsumeAmountSts request) {
        int flag = mapper.insert(request);
        if (flag == 1) {
            return 1;
        } else {
            throw new AppRuntimeException(ResponseCode.EXCEPTION, "新增失败");
        }
    }


    /**
     * 保存或修改记录信息
     *
     * @param request 需要保存的入参实体类
     * @return int 是否保存或修改成功
     * author 建投数据科技(山东)有限公司
     * @date 2020-3-11 20:54:09
     */
    @Override
    public int saveOrUpdate(MemberConsumeAmountSts request) {
        log.info("保存或修改记录信息，入参 = {}", JSONObject.toJSONString(request));
        try {
            if (request == null) {
                throw new AppRuntimeException(ResponseCode.EXCEPTION, "入参为空");
            }
            if (request.getId() != null && request.getId() != 0) {
                log.info("保存或修改记录信息，修改，入参 = {}", JSONObject.toJSONString(request));
                int flag = mapper.updateByPrimaryKey(request);
                if (flag == 1) {
                    return 1;
                }
            } else {
                log.info("保存或修改记录信息，保存，入参 = {}", JSONObject.toJSONString(request));
                int flag = mapper.insertSelective(request);
                if (flag == 1) {
                    return 1;
                } else {
                    throw new AppRuntimeException(ResponseCode.EXCEPTION, "修改失败");
                }
            }
        } catch (Exception e) {
            log.error("用户保存或修改失败", e);
            throw new AppRuntimeException(ResponseCode.EXCEPTION, "用户保存或修改失败");
        }
        return -1;
    }

    /**
     * 删除记录
     *
     * @param request 需要删除,含有主键的入参实体类
     * @return int 是否删除成功
     */
    @Override
    public int deleteByPrimaryKey(MemberConsumeAmountSts request) {
        int flag = mapper.deleteByPrimaryKey(request);
        if (flag == 1) {
            return 1;
        } else {
            throw new AppRuntimeException(ResponseCode.EXCEPTION, "删除失败");
        }
    }


    /**
     * 逻辑删除记录
     *
     * @param request 含有主键的逻辑删除实体类
     * @return int 是否逻辑删除成功
     */
    @Override
    public int deleteByPrimaryKeyLogically(MemberConsumeAmountSts request) {
        request.setDeleteFlag(1);
        int flag = mapper.updateByPrimaryKey(request);
        if (flag == 1) {
            return 1;
        } else {
            throw new AppRuntimeException(ResponseCode.EXCEPTION, "逻辑删除记录失败");
        }
    }


    /**
     * 修改
     *
     * @param request
     * @return
     */
    @Override
    public int updateByPrimaryKeySelective(MemberConsumeAmountSts request) {
        try {
            log.info("修改记录");
            MemberConsumeAmountSts param = new MemberConsumeAmountSts();
            BeanUtils.copyProperties(request, param);
            int flag = mapper.updateByPrimaryKeySelective(param);
            if (flag == 1) {
                return 1;
            } else {
                throw new AppRuntimeException(ResponseCode.EXCEPTION, "修改记录失败");
            }
        } catch (Exception e) {
            log.error("修改记录失败", e);
            throw new AppRuntimeException(ResponseCode.EXCEPTION, "修改记录失败");
        }

    }

    /**
     * 记录详情
     *
     * @param request 查询的入参实体类
     * @return 数据库查询到的实体类
     */
    @Override
    public MemberConsumeAmountSts getByPrimaryKey(MemberConsumeAmountSts request) {
        return mapper.selectByPrimaryKey(request);
    }


    /**
     * 分页查询
     *
     * @param request 分页查询入参实体类
     * @return 含有分页信息的实体类列表
     */
    @Override
    public PageInfo<MemberConsumeAmountSts> listPageBySelective(MemberConsumeAmountSts request, int pageNum, int pageSize) {
        PageHelper.startPage(pageNum, pageSize);
        PageHelper.orderBy(" create_time desc");
        List<MemberConsumeAmountSts> list = mapper.listPageBySelective(request);
        return new PageInfo(list);
    }

    /**
     * 不分页查询
     *
     * @param request 不分页查询入参实体类
     * @return 数据库查到的实体类列表
     */
    @Override
    public List<MemberConsumeAmountSts> listAllRecord(MemberConsumeAmountSts request) {
        //分页处理
        request.setDeleteFlag(0);
        return mapper.selectBySelective(request);
    }


    /**
     * 会员【活跃时间段】统计-饼状图
     * @param request 查询入参实体类
     * @return 实体类列表
     * @author tzc
     * @date 2020-5-21 11:46:19
     */
    @Override
    public Map<String,Integer> getDistributeOfConsumeAmount(MemberConsumeAmountSts request) {
        request.setDeleteFlag(0);
        List<MemberConsumeAmountSts> list = mapper.selectBySelective(request);
        Integer less100       =0;
        Integer total100To600  =0;
        Integer total600To1100  =0;
        Integer total1100To1600 =0;
        Integer total1600To2100=0;
        Integer total2100To2600=0;
        Integer total2600To3100=0;
        Integer total3100To3600=0;
        Integer total3600To4100=0;
        Integer total4100To4600=0;
        Integer total4600To5000=0;
        Integer more5000=0;
        if (list != null  && list.size()!=1){
            throw new AppRuntimeException("无法获取唯一的记录");
        }

        MemberConsumeAmountSts memberConsumeAmountSts = list.get(0);
        String periodStsData = memberConsumeAmountSts.getPeriodStsData();
        JSONArray jsonArray = JSONArray.parseArray(periodStsData);
        for (Object json: jsonArray) {
            JSONObject jsonObject = (JSONObject) json;
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("less100")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        less100 = less100 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("100-600")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total100To600 = total100To600 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("600-1100")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total600To1100 = total600To1100 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("1100-1600")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total1100To1600 = total1100To1600 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("1600-2100")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total1600To2100 = total1600To2100 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("2100-2600")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total2100To2600 = total2100To2600 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("2600-3100")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total2600To3100 = total2600To3100 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("3100-3600")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total3100To3600 = total3100To3600 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("3600-4100")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total3600To4100 = total3600To4100 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("4100-4600")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total4100To4600 = total4100To4600 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("4600-5000")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        total4600To5000 = total4600To5000 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
            if (jsonObject.containsKey("consumePeriodName") && jsonObject.get("consumePeriodName").equals("more5000")){
                if (jsonObject.containsKey("memberNumber") && null != jsonObject.get("memberNumber")){
                    Object memberNumber = jsonObject.get("memberNumber");
                    if (StringUtils.isNumber(String.valueOf(memberNumber))){
                        more5000 = more5000 + Integer.valueOf(memberNumber+"");
                    }
                }
            }
        }

        Map<String,Integer> map = new HashMap<>();
        map.put("less100",less100);
        map.put("total100To600",total100To600);
        map.put("total600To1100",total600To1100);
        map.put("total1100To1600",total1100To1600);
        map.put("total1600To2100",total1600To2100);
        map.put("total2100To2600",total2100To2600);
        map.put("total2600To3100",total2600To3100);
        map.put("total3100To3600",total3100To3600);
        map.put("total3600To4100",total3600To4100);
        map.put("total4100To4600",total4100To4600);
        map.put("total4600To5000",total4600To5000);
        map.put("more5000",more5000);

        return map;
    }




}
